﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Store Manager/SM_panel.master" AutoEventWireup="true" CodeFile="SM_PhysicalStock.aspx.cs" Inherits="Store_Manager_SM_PhysicalStock" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
    ClientIDMode="AutoID" CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
    CssPostfix="BlackGlass" DataSourceID="SqlDataSource1" KeyFieldName="IssuSto_ID" 
    Width="100%">
    <Columns>
        <dx:GridViewCommandColumn VisibleIndex="0">
            <EditButton Visible="True">
            </EditButton>
            <ClearFilterButton Visible="True">
            </ClearFilterButton>
        </dx:GridViewCommandColumn>
        <dx:GridViewDataTextColumn Caption="Stock Code" FieldName="IssuSto_ID" 
            ReadOnly="True" VisibleIndex="0">
            <EditFormSettings Visible="False" />
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn Caption="Item ID" FieldName="Pro_ID" ReadOnly="True" 
            VisibleIndex="1">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn Caption="Item Code" FieldName="Code" 
            VisibleIndex="2">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn Caption="Item" FieldName="Pro_Name" VisibleIndex="3">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn Caption="Panadura Quantity" FieldName="Qty_in_stock" 
            VisibleIndex="4">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn Caption="Kandy Quantity" FieldName="Kandy_Quantity" 
            VisibleIndex="6">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn Caption="Re Order Level" FieldName="Re_Order_Level" 
            VisibleIndex="5">
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn Caption="Re Order Quantity" FieldName="Re_Order_qty" 
            VisibleIndex="7">
        </dx:GridViewDataTextColumn>
    </Columns>
        <SettingsPager PageSize="25">
        </SettingsPager>
    <Settings ShowFilterRow="True" />
    <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
        <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
        </LoadingPanelOnStatusBar>
        <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
        </LoadingPanel>
    </Images>
    <ImagesFilterControl>
        <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
        </LoadingPanel>
    </ImagesFilterControl>
    <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
        CssPostfix="BlackGlass">
        <Header ImageSpacing="5px" SortingImageSpacing="5px">
        </Header>
    </Styles>
    <StylesEditors>
        <CalendarHeader Spacing="1px">
        </CalendarHeader>
        <ProgressBar Height="25px">
        </ProgressBar>
    </StylesEditors>
</dx:ASPxGridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
    DeleteCommand="DELETE FROM [Tbl_Issue_Stock] WHERE [IssuSto_ID] = @IssuSto_ID AND [Pro_ID] = @Pro_ID" 
    InsertCommand="INSERT INTO [Tbl_Issue_Stock] ([Pro_Name], [Code], [Qty_in_stock], [Re_Order_Level], [Re_Order_qty], [Pro_ID], [Kandy_Quantity]) VALUES (@Pro_Name, @Code, @Qty_in_stock, @Re_Order_Level, @Re_Order_qty, @Pro_ID, @Kandy_Quantity)" 
    SelectCommand="SELECT [IssuSto_ID], [Pro_Name], [Code], [Qty_in_stock], [Re_Order_Level], [Re_Order_qty], [Pro_ID], [Kandy_Quantity] FROM [Tbl_Issue_Stock]" 
    
        UpdateCommand="UPDATE [Tbl_Issue_Stock] SET [Pro_Name] = @Pro_Name, [Code] = @Code, [Qty_in_stock] = @Qty_in_stock, [Re_Order_Level] = @Re_Order_Level, [Re_Order_qty] = @Re_Order_qty, [Kandy_Quantity] = @Kandy_Quantity WHERE [IssuSto_ID] = @IssuSto_ID AND [Pro_ID] = @Pro_ID">
    <DeleteParameters>
        <asp:Parameter Name="IssuSto_ID" Type="Int32" />
        <asp:Parameter Name="Pro_ID" Type="String" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="Pro_Name" Type="String" />
        <asp:Parameter Name="Code" Type="String" />
        <asp:Parameter Name="Qty_in_stock" Type="Decimal" />
        <asp:Parameter Name="Re_Order_Level" Type="Decimal" />
        <asp:Parameter Name="Re_Order_qty" Type="Decimal" />
        <asp:Parameter Name="Pro_ID" Type="String" />
        <asp:Parameter Name="Kandy_Quantity" Type="Decimal" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="Pro_Name" Type="String" />
        <asp:Parameter Name="Code" Type="String" />
        <asp:Parameter Name="Qty_in_stock" Type="Decimal" />
        <asp:Parameter Name="Re_Order_Level" Type="Decimal" />
        <asp:Parameter Name="Re_Order_qty" Type="Decimal" />
        <asp:Parameter Name="Kandy_Quantity" Type="Decimal" />
        <asp:Parameter Name="IssuSto_ID" Type="Int32" />
        <asp:Parameter Name="Pro_ID" Type="String" />
    </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>

